<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsKPO" targetNamespace="http://tempuri.org/dsKPO.xsd" xmlns:mstns="http://tempuri.org/dsKPO.xsd" xmlns="http://tempuri.org/dsKPO.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="p301ConnString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="p301ConnString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.p301.Properties.Settings.GlobalReference.Default.p301ConnString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKPO" GeneratorDataComponentClassName="taKPO" Name="dtKPO" UserDataComponentName="taKPO">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_kpo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     K_KPO, K_UKS, NPP_KPO, K_OBRASCH, F_DEN, F_KRIZIS, D_OBRASCH, V_OBRASCH, K_INF_CENTR, F_KLIENT, GOD_R, K_ADR, N_PRICH, 
                      F_KONS, K_SPEC, D_KONS, V_KONS, K_HELP_ORG, N_HELP, K_SP, F_DETI, K_UP, K_OBR, K_SOCSTAT, K_RAB, K_PRICH, K_POM, N_PRIM, 
                      K_KONS, N_FA, N_IM, N_OT, K_POL,
                          (SELECT     NPP_UKSyear
                            FROM          vUks
                            WHERE      (K_UKS = b_kpo.K_UKS)) AS NPP_UKS, LTRIM(STR(NPP_KPO)) + ' - ' + LTRIM(STR(YEAR(D_OBRASCH))) AS NPP_KPOyear, 
                      YEAR(GETDATE()) - GOD_R AS C_LET
FROM         b_kpo
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.b_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_kpo] SET [K_UKS] = @K_UKS, [NPP_KPO] = @NPP_KPO, [K_OBRASCH] = @K_OBRASCH, [F_DEN] = @F_DEN, [F_KRIZIS] = @F_KRIZIS, [D_OBRASCH] = @D_OBRASCH, [V_OBRASCH] = @V_OBRASCH, [K_INF_CENTR] = @K_INF_CENTR, [F_KLIENT] = @F_KLIENT, [GOD_R] = @GOD_R, [K_ADR] = @K_ADR, [N_PRICH] = @N_PRICH, [F_KONS] = @F_KONS, [K_SPEC] = @K_SPEC, [D_KONS] = @D_KONS, [V_KONS] = @V_KONS, [K_HELP_ORG] = @K_HELP_ORG, [N_HELP] = @N_HELP, [K_SP] = @K_SP, [F_DETI] = @F_DETI, [K_UP] = @K_UP, [K_OBR] = @K_OBR, [K_SOCSTAT] = @K_SOCSTAT, [K_RAB] = @K_RAB, [K_PRICH] = @K_PRICH, [K_POM] = @K_POM, [N_PRIM] = @N_PRIM, [K_KONS] = @K_KONS, [N_FA] = @N_FA, [N_IM] = @N_IM, [N_OT] = @N_OT, [K_POL] = @K_POL WHERE (([K_KPO] = @Original_K_KPO))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UKS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NPP_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NPP_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_OBRASCH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_OBRASCH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DEN" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DEN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_KRIZIS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_KRIZIS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_OBRASCH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_OBRASCH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@V_OBRASCH" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="V_OBRASCH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_INF_CENTR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_INF_CENTR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_KLIENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_KLIENT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_PRICH" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="N_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_KONS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SPEC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SPEC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@D_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="D_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@V_KONS" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="V_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_HELP_ORG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_HELP_ORG" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_HELP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_HELP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_DETI" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_DETI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_OBR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_OBR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_SOCSTAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOCSTAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_POM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_POM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_PRIM" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="N_PRIM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KONS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KONS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="NPP_KPO" DataSetColumn="NPP_KPO" />
              <Mapping SourceColumn="K_OBRASCH" DataSetColumn="K_OBRASCH" />
              <Mapping SourceColumn="F_DEN" DataSetColumn="F_DEN" />
              <Mapping SourceColumn="F_KRIZIS" DataSetColumn="F_KRIZIS" />
              <Mapping SourceColumn="D_OBRASCH" DataSetColumn="D_OBRASCH" />
              <Mapping SourceColumn="V_OBRASCH" DataSetColumn="V_OBRASCH" />
              <Mapping SourceColumn="K_INF_CENTR" DataSetColumn="K_INF_CENTR" />
              <Mapping SourceColumn="F_KLIENT" DataSetColumn="F_KLIENT" />
              <Mapping SourceColumn="GOD_R" DataSetColumn="GOD_R" />
              <Mapping SourceColumn="K_ADR" DataSetColumn="K_ADR" />
              <Mapping SourceColumn="N_PRICH" DataSetColumn="N_PRICH" />
              <Mapping SourceColumn="F_KONS" DataSetColumn="F_KONS" />
              <Mapping SourceColumn="K_SPEC" DataSetColumn="K_SPEC" />
              <Mapping SourceColumn="D_KONS" DataSetColumn="D_KONS" />
              <Mapping SourceColumn="V_KONS" DataSetColumn="V_KONS" />
              <Mapping SourceColumn="K_HELP_ORG" DataSetColumn="K_HELP_ORG" />
              <Mapping SourceColumn="N_HELP" DataSetColumn="N_HELP" />
              <Mapping SourceColumn="K_SP" DataSetColumn="K_SP" />
              <Mapping SourceColumn="F_DETI" DataSetColumn="F_DETI" />
              <Mapping SourceColumn="K_UP" DataSetColumn="K_UP" />
              <Mapping SourceColumn="K_OBR" DataSetColumn="K_OBR" />
              <Mapping SourceColumn="K_SOCSTAT" DataSetColumn="K_SOCSTAT" />
              <Mapping SourceColumn="K_RAB" DataSetColumn="K_RAB" />
              <Mapping SourceColumn="K_PRICH" DataSetColumn="K_PRICH" />
              <Mapping SourceColumn="K_POM" DataSetColumn="K_POM" />
              <Mapping SourceColumn="N_PRIM" DataSetColumn="N_PRIM" />
              <Mapping SourceColumn="K_KONS" DataSetColumn="K_KONS" />
              <Mapping SourceColumn="N_FA" DataSetColumn="N_FA" />
              <Mapping SourceColumn="N_IM" DataSetColumn="N_IM" />
              <Mapping SourceColumn="N_OT" DataSetColumn="N_OT" />
              <Mapping SourceColumn="K_POL" DataSetColumn="K_POL" />
              <Mapping SourceColumn="NPP_UKS" DataSetColumn="NPP_UKS" />
              <Mapping SourceColumn="NPP_KPOyear" DataSetColumn="NPP_KPOyear" />
              <Mapping SourceColumn="C_LET" DataSetColumn="C_LET" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taAdr" GeneratorDataComponentClassName="taAdr" Name="dtAdr" UserDataComponentName="taAdr">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_adr" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>select *
from b_adr
where K_ADR = @pK_ADR</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="pK_ADR" ColumnName="K_ADR" DataSourceName="p301.dbo.b_adr" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_ADR" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [b_adr] SET [K_UL] = @K_UL, [A_DOM] = @A_DOM, [A_KORP] = @A_KORP, [A_KV] = @A_KV, [A_GOROD] = @A_GOROD, [A_OBL] = @A_OBL, [A_RN] = @A_RN, [K_RN_G] = @K_RN_G, [N_TEL] = @N_TEL, [F_TEL_RAB] = @F_TEL_RAB WHERE (([K_ADR] = @Original_K_ADR))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_UL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_UL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_DOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_DOM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_KORP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_KORP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@A_KV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="A_KV" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_GOROD" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_GOROD" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_OBL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_OBL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@A_RN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="A_RN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RN_G" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RN_G" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_TEL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_TEL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@F_TEL_RAB" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="F_TEL_RAB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_ADR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_ADR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_ADR" DataSetColumn="K_ADR" />
              <Mapping SourceColumn="A_OBL" DataSetColumn="A_OBL" />
              <Mapping SourceColumn="A_GOROD" DataSetColumn="A_GOROD" />
              <Mapping SourceColumn="A_RN" DataSetColumn="A_RN" />
              <Mapping SourceColumn="A_DOM" DataSetColumn="A_DOM" />
              <Mapping SourceColumn="A_KORP" DataSetColumn="A_KORP" />
              <Mapping SourceColumn="A_KV" DataSetColumn="A_KV" />
              <Mapping SourceColumn="K_RN_G" DataSetColumn="K_RN_G" />
              <Mapping SourceColumn="K_UL" DataSetColumn="K_UL" />
              <Mapping SourceColumn="N_TEL" DataSetColumn="N_TEL" />
              <Mapping SourceColumn="F_TEL_RAB" DataSetColumn="F_TEL_RAB" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taSostavSemyi" GeneratorDataComponentClassName="taSostavSemyi" Name="dtSostavSemyi" UserDataComponentName="taSostavSemyi">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_sostav_semyi_kpo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [b_sostav_semyi_kpo] WHERE (([K_SOSTAV_SEMYI] = @Original_K_SOSTAV_SEMYI))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_SOSTAV_SEMYI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_SOSTAV_SEMYI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [b_sostav_semyi_kpo] ([K_KPO], [N_FA], [N_IM], [N_OT], [GOD_R], [K_RODSTV_OTN], [N_PRIM], [K_POL]) VALUES (@K_KPO, @N_FA, @N_IM, @N_OT, @GOD_R, @K_RODSTV_OTN, @N_PRIM, @K_POL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@N_PRIM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="N_PRIM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_SOSTAV_SEMYI, K_KPO, N_FA, N_IM, N_OT, GOD_R, Year(GetDate()) - GOD_R as C_LET, K_RODSTV_OTN, N_PRIM, K_POL
FROM         b_sostav_semyi_kpo
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    b_sostav_semyi_kpo
SET              K_KPO = @K_KPO, N_FA = @N_FA, N_IM = @N_IM, N_OT = @N_OT, GOD_R = @GOD_R, K_RODSTV_OTN = @K_RODSTV_OTN, N_PRIM = @N_PRIM, 
                      K_POL = @K_POL
WHERE     (K_SOSTAV_SEMYI = @Original_K_SOSTAV_SEMYI)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="K_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="N_FA" ColumnName="N_FA" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@N_FA" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="N_FA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="N_IM" ColumnName="N_IM" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@N_IM" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="N_IM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="N_OT" ColumnName="N_OT" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@N_OT" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="N_OT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="GOD_R" ColumnName="GOD_R" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@GOD_R" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="GOD_R" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="K_RODSTV_OTN" ColumnName="K_RODSTV_OTN" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@K_RODSTV_OTN" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_RODSTV_OTN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="N_PRIM" ColumnName="N_PRIM" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@N_PRIM" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="N_PRIM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="K_POL" ColumnName="K_POL" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="tinyint" DbType="Int32" Direction="Input" ParameterName="@K_POL" Precision="0" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="K_POL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Original_K_SOSTAV_SEMYI" ColumnName="K_SOSTAV_SEMYI" DataSourceName="p301.dbo.b_sostav_semyi_kpo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_K_SOSTAV_SEMYI" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_SOSTAV_SEMYI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_SOSTAV_SEMYI" DataSetColumn="K_SOSTAV_SEMYI" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="N_FA" DataSetColumn="N_FA" />
              <Mapping SourceColumn="N_IM" DataSetColumn="N_IM" />
              <Mapping SourceColumn="N_OT" DataSetColumn="N_OT" />
              <Mapping SourceColumn="GOD_R" DataSetColumn="GOD_R" />
              <Mapping SourceColumn="K_RODSTV_OTN" DataSetColumn="K_RODSTV_OTN" />
              <Mapping SourceColumn="N_PRIM" DataSetColumn="N_PRIM" />
              <Mapping SourceColumn="K_POL" DataSetColumn="K_POL" />
              <Mapping SourceColumn="C_LET" DataSetColumn="C_LET" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKpoPrich" GeneratorDataComponentClassName="taKpoPrich" Name="dtKpoPrich" UserDataComponentName="taKpoPrich">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.sv_kpo_prich" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [sv_kpo_prich] WHERE (([K_KPO_PRICH] = @Original_K_KPO_PRICH))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_PRICH" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [sv_kpo_prich] ([K_KPO], [K_PRICH]) VALUES (@K_KPO, @K_PRICH)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     sv_kpo_prich.*
FROM         sv_kpo_prich
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.sv_kpo_prich" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [sv_kpo_prich] SET [K_KPO] = @K_KPO, [K_PRICH] = @K_PRICH WHERE (([K_KPO_PRICH] = @Original_K_KPO_PRICH))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PRICH" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_PRICH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_PRICH" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO_PRICH" DataSetColumn="K_KPO_PRICH" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_PRICH" DataSetColumn="K_PRICH" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKpoPom" GeneratorDataComponentClassName="taKpoPom" Name="dtKpoPom" UserDataComponentName="taKpoPom">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.sv_kpo_pom" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [sv_kpo_pom] WHERE (([K_KPO_POM] = @Original_K_KPO_POM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_POM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_POM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [sv_kpo_pom] ([K_KPO], [K_POM]) VALUES (@K_KPO, @K_POM)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_POM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_POM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     sv_kpo_pom.*
FROM         sv_kpo_pom
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.sv_kpo_pom" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [sv_kpo_pom] SET [K_KPO] = @K_KPO, [K_POM] = @K_POM WHERE (([K_KPO_POM] = @Original_K_KPO_POM))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_POM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_POM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_POM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_POM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO_POM" DataSetColumn="K_KPO_POM" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_POM" DataSetColumn="K_POM" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKpoHelpOrg" GeneratorDataComponentClassName="taKpoHelpOrg" Name="dtKpoHelpOrg" UserDataComponentName="taKpoHelpOrg">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.sv_kpo_help_org" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [sv_kpo_help_org] WHERE (([K_KPO_HELP_ORG] = @Original_K_KPO_HELP_ORG))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_HELP_ORG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_HELP_ORG" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [sv_kpo_help_org] ([K_KPO], [K_HELP_ORG]) VALUES (@K_KPO, @K_HELP_ORG)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_HELP_ORG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_HELP_ORG" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     sv_kpo_help_org.*
FROM         sv_kpo_help_org
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.sv_kpo_help_org" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [sv_kpo_help_org] SET [K_KPO] = @K_KPO, [K_HELP_ORG] = @K_HELP_ORG WHERE (([K_KPO_HELP_ORG] = @Original_K_KPO_HELP_ORG))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_HELP_ORG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_HELP_ORG" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_HELP_ORG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_HELP_ORG" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO_HELP_ORG" DataSetColumn="K_KPO_HELP_ORG" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_HELP_ORG" DataSetColumn="K_HELP_ORG" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taZhurnalObrasch" GeneratorDataComponentClassName="taZhurnalObrasch" Name="dtZhurnalObrasch" UserDataComponentName="taZhurnalObrasch">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.b_zhurnal_obrasch" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT    CASE ISNULL(N_FA,'')  WHEN  '' THEN '' ELSE N_FA + ' ' end +  		
		  CASE ISNULL(N_IM,'')  WHEN  '' THEN '' ELSE N_IM + ' ' end +
		  CASE ISNULL(N_OT,'')  WHEN  '' THEN '' ELSE N_OT  end as N_FIO,
C_NPP, D_OBRASCH, F_PROVEDENA, K_KPO
FROM         b_zhurnal_obrasch
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.b_zhurnal_obrasch" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="C_NPP" DataSetColumn="C_NPP" />
              <Mapping SourceColumn="D_OBRASCH" DataSetColumn="D_OBRASCH" />
              <Mapping SourceColumn="F_PROVEDENA" DataSetColumn="F_PROVEDENA" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="N_FIO" DataSetColumn="N_FIO" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taKpoProb" GeneratorDataComponentClassName="taKpoProb" Name="dtKpoProb" UserDataComponentName="taKpoProb">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.sv_kpo_prob" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [sv_kpo_prob] WHERE (([K_KPO_PROB] = @Original_K_KPO_PROB))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_PROB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_PROB" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [sv_kpo_prob] ([K_KPO], [K_PROB], [K_PROB_TIP]) VALUES (@K_KPO, @K_PROB, @K_PROB_TIP)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PROB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PROB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PROB_TIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PROB_TIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     sv_kpo_prob.*
FROM         sv_kpo_prob
WHERE     (K_KPO = @pK_KPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="pK_KPO" ColumnName="K_KPO" DataSourceName="p301.dbo.sv_kpo_prob" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_KPO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [sv_kpo_prob] SET [K_KPO] = @K_KPO, [K_PROB] = @K_PROB, [K_PROB_TIP] = @K_PROB_TIP WHERE (([K_KPO_PROB] = @Original_K_KPO_PROB))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_KPO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PROB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PROB" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@K_PROB_TIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_PROB_TIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_K_KPO_PROB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="K_KPO_PROB" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_KPO_PROB" DataSetColumn="K_KPO_PROB" />
              <Mapping SourceColumn="K_KPO" DataSetColumn="K_KPO" />
              <Mapping SourceColumn="K_PROB" DataSetColumn="K_PROB" />
              <Mapping SourceColumn="K_PROB_TIP" DataSetColumn="K_PROB_TIP" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="taUKS" GeneratorDataComponentClassName="taUKS" Name="dtUKS" UserDataComponentName="taUKS">
            <MainSource>
              <DbSource ConnectionRef="p301ConnString (Settings)" DbObjectName="p301.dbo.vUks" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="False" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     K_UKS,  'УКС ' + NPP_UKSyear as NPP_UKS FROM         vUks
WHERE     (K_UKS = @pK_UKS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="pK_UKS" ColumnName="K_UKS" DataSourceName="p301.dbo.vUks" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@pK_UKS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="K_UKS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="K_UKS" DataSetColumn="K_UKS" />
              <Mapping SourceColumn="NPP_UKS" DataSetColumn="NPP_UKS" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsKPO" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsKPO" msprop:Generator_DataSetName="dsKPO">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtKPO" msprop:Generator_UserTableName="dtKPO" msprop:Generator_RowDeletedName="dtKPORowDeleted" msprop:Generator_RowChangedName="dtKPORowChanged" msprop:Generator_RowClassName="dtKPORow" msprop:Generator_RowChangingName="dtKPORowChanging" msprop:Generator_RowEvArgName="dtKPORowChangeEvent" msprop:Generator_RowEvHandlerName="dtKPORowChangeEventHandler" msprop:Generator_TableClassName="dtKPODataTable" msprop:Generator_TableVarName="tabledtKPO" msprop:Generator_RowDeletingName="dtKPORowDeleting" msprop:Generator_TablePropName="dtKPO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" />
              <xs:element name="K_UKS" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NPP_KPO" msprop:Generator_UserColumnName="NPP_KPO" msprop:Generator_ColumnPropNameInRow="NPP_KPO" msprop:Generator_ColumnVarNameInTable="columnNPP_KPO" msprop:Generator_ColumnPropNameInTable="NPP_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_OBRASCH" msprop:Generator_UserColumnName="K_OBRASCH" msprop:Generator_ColumnPropNameInRow="K_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnK_OBRASCH" msprop:Generator_ColumnPropNameInTable="K_OBRASCHColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_DEN" msprop:Generator_UserColumnName="F_DEN" msprop:Generator_ColumnPropNameInRow="F_DEN" msprop:Generator_ColumnVarNameInTable="columnF_DEN" msprop:Generator_ColumnPropNameInTable="F_DENColumn" type="xs:boolean" default="false" />
              <xs:element name="F_KRIZIS" msprop:Generator_UserColumnName="F_KRIZIS" msprop:Generator_ColumnPropNameInRow="F_KRIZIS" msprop:Generator_ColumnVarNameInTable="columnF_KRIZIS" msprop:Generator_ColumnPropNameInTable="F_KRIZISColumn" type="xs:boolean" default="false" />
              <xs:element name="D_OBRASCH" msprop:Generator_UserColumnName="D_OBRASCH" msprop:Generator_ColumnPropNameInRow="D_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnD_OBRASCH" msprop:Generator_ColumnPropNameInTable="D_OBRASCHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="V_OBRASCH" msprop:Generator_UserColumnName="V_OBRASCH" msprop:Generator_ColumnPropNameInRow="V_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnV_OBRASCH" msprop:Generator_ColumnPropNameInTable="V_OBRASCHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="K_INF_CENTR" msprop:Generator_UserColumnName="K_INF_CENTR" msprop:Generator_ColumnPropNameInRow="K_INF_CENTR" msprop:Generator_ColumnVarNameInTable="columnK_INF_CENTR" msprop:Generator_ColumnPropNameInTable="K_INF_CENTRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_KLIENT" msprop:Generator_UserColumnName="F_KLIENT" msprop:Generator_ColumnPropNameInRow="F_KLIENT" msprop:Generator_ColumnVarNameInTable="columnF_KLIENT" msprop:Generator_ColumnPropNameInTable="F_KLIENTColumn" type="xs:boolean" default="false" />
              <xs:element name="GOD_R" msprop:Generator_UserColumnName="GOD_R" msprop:Generator_ColumnPropNameInRow="GOD_R" msprop:Generator_ColumnVarNameInTable="columnGOD_R" msprop:Generator_ColumnPropNameInTable="GOD_RColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_ADR" msprop:Generator_UserColumnName="K_ADR" msprop:Generator_ColumnPropNameInRow="K_ADR" msprop:Generator_ColumnVarNameInTable="columnK_ADR" msprop:Generator_ColumnPropNameInTable="K_ADRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_PRICH" msprop:Generator_UserColumnName="N_PRICH" msprop:Generator_ColumnPropNameInRow="N_PRICH" msprop:Generator_ColumnVarNameInTable="columnN_PRICH" msprop:Generator_ColumnPropNameInTable="N_PRICHColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="F_KONS" msprop:Generator_UserColumnName="F_KONS" msprop:Generator_ColumnPropNameInRow="F_KONS" msprop:Generator_ColumnVarNameInTable="columnF_KONS" msprop:Generator_ColumnPropNameInTable="F_KONSColumn" type="xs:boolean" default="false" />
              <xs:element name="K_SPEC" msprop:Generator_UserColumnName="K_SPEC" msprop:Generator_ColumnPropNameInRow="K_SPEC" msprop:Generator_ColumnVarNameInTable="columnK_SPEC" msprop:Generator_ColumnPropNameInTable="K_SPECColumn" type="xs:int" minOccurs="0" />
              <xs:element name="D_KONS" msprop:Generator_UserColumnName="D_KONS" msprop:Generator_ColumnPropNameInRow="D_KONS" msprop:Generator_ColumnVarNameInTable="columnD_KONS" msprop:Generator_ColumnPropNameInTable="D_KONSColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="V_KONS" msprop:Generator_UserColumnName="V_KONS" msprop:Generator_ColumnPropNameInRow="V_KONS" msprop:Generator_ColumnVarNameInTable="columnV_KONS" msprop:Generator_ColumnPropNameInTable="V_KONSColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="K_HELP_ORG" msprop:Generator_UserColumnName="K_HELP_ORG" msprop:Generator_ColumnPropNameInRow="K_HELP_ORG" msprop:Generator_ColumnVarNameInTable="columnK_HELP_ORG" msprop:Generator_ColumnPropNameInTable="K_HELP_ORGColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_HELP" msprop:Generator_UserColumnName="N_HELP" msprop:Generator_ColumnPropNameInRow="N_HELP" msprop:Generator_ColumnVarNameInTable="columnN_HELP" msprop:Generator_ColumnPropNameInTable="N_HELPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_SP" msprop:Generator_UserColumnName="K_SP" msprop:Generator_ColumnPropNameInRow="K_SP" msprop:Generator_ColumnVarNameInTable="columnK_SP" msprop:Generator_ColumnPropNameInTable="K_SPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="F_DETI" msprop:Generator_UserColumnName="F_DETI" msprop:Generator_ColumnPropNameInRow="F_DETI" msprop:Generator_ColumnVarNameInTable="columnF_DETI" msprop:Generator_ColumnPropNameInTable="F_DETIColumn" type="xs:boolean" default="false" />
              <xs:element name="K_UP" msprop:Generator_UserColumnName="K_UP" msprop:Generator_ColumnPropNameInRow="K_UP" msprop:Generator_ColumnVarNameInTable="columnK_UP" msprop:Generator_ColumnPropNameInTable="K_UPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_OBR" msprop:Generator_UserColumnName="K_OBR" msprop:Generator_ColumnPropNameInRow="K_OBR" msprop:Generator_ColumnVarNameInTable="columnK_OBR" msprop:Generator_ColumnPropNameInTable="K_OBRColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_SOCSTAT" msprop:Generator_UserColumnName="K_SOCSTAT" msprop:Generator_ColumnPropNameInRow="K_SOCSTAT" msprop:Generator_ColumnVarNameInTable="columnK_SOCSTAT" msprop:Generator_ColumnPropNameInTable="K_SOCSTATColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RAB" msprop:Generator_UserColumnName="K_RAB" msprop:Generator_ColumnPropNameInRow="K_RAB" msprop:Generator_ColumnVarNameInTable="columnK_RAB" msprop:Generator_ColumnPropNameInTable="K_RABColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_PRICH" msprop:Generator_UserColumnName="K_PRICH" msprop:Generator_ColumnPropNameInRow="K_PRICH" msprop:Generator_ColumnVarNameInTable="columnK_PRICH" msprop:Generator_ColumnPropNameInTable="K_PRICHColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_POM" msprop:Generator_UserColumnName="K_POM" msprop:Generator_ColumnPropNameInRow="K_POM" msprop:Generator_ColumnVarNameInTable="columnK_POM" msprop:Generator_ColumnPropNameInTable="K_POMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_PRIM" msprop:Generator_UserColumnName="N_PRIM" msprop:Generator_ColumnPropNameInRow="N_PRIM" msprop:Generator_ColumnVarNameInTable="columnN_PRIM" msprop:Generator_ColumnPropNameInTable="N_PRIMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_KONS" msprop:Generator_UserColumnName="K_KONS" msprop:Generator_ColumnPropNameInRow="K_KONS" msprop:Generator_ColumnVarNameInTable="columnK_KONS" msprop:Generator_ColumnPropNameInTable="K_KONSColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_FA" msprop:Generator_UserColumnName="N_FA" msprop:Generator_ColumnPropNameInRow="N_FA" msprop:Generator_ColumnVarNameInTable="columnN_FA" msprop:Generator_ColumnPropNameInTable="N_FAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_IM" msprop:Generator_UserColumnName="N_IM" msprop:Generator_ColumnPropNameInRow="N_IM" msprop:Generator_ColumnVarNameInTable="columnN_IM" msprop:Generator_ColumnPropNameInTable="N_IMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_OT" msprop:Generator_UserColumnName="N_OT" msprop:Generator_ColumnPropNameInRow="N_OT" msprop:Generator_ColumnVarNameInTable="columnN_OT" msprop:Generator_ColumnPropNameInTable="N_OTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_POL" msprop:Generator_UserColumnName="K_POL" msprop:Generator_ColumnPropNameInRow="K_POL" msprop:Generator_ColumnVarNameInTable="columnK_POL" msprop:Generator_ColumnPropNameInTable="K_POLColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="NPP_UKS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NPP_UKS" msprop:Generator_ColumnPropNameInRow="NPP_UKS" msprop:Generator_ColumnVarNameInTable="columnNPP_UKS" msprop:Generator_ColumnPropNameInTable="NPP_UKSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="23" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NPP_KPOyear" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NPP_KPOyear" msprop:Generator_ColumnPropNameInRow="NPP_KPOyear" msprop:Generator_ColumnVarNameInTable="columnNPP_KPOyear" msprop:Generator_ColumnPropNameInTable="NPP_KPOyearColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="23" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="C_LET" msprop:Generator_UserColumnName="C_LET" msprop:Generator_ColumnVarNameInTable="columnC_LET" msprop:Generator_ColumnPropNameInRow="C_LET" msprop:Generator_ColumnPropNameInTable="C_LETColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtAdr" msprop:Generator_UserTableName="dtAdr" msprop:Generator_RowDeletedName="dtAdrRowDeleted" msprop:Generator_RowChangedName="dtAdrRowChanged" msprop:Generator_RowClassName="dtAdrRow" msprop:Generator_RowChangingName="dtAdrRowChanging" msprop:Generator_RowEvArgName="dtAdrRowChangeEvent" msprop:Generator_RowEvHandlerName="dtAdrRowChangeEventHandler" msprop:Generator_TableClassName="dtAdrDataTable" msprop:Generator_TableVarName="tabledtAdr" msprop:Generator_RowDeletingName="dtAdrRowDeleting" msprop:Generator_TablePropName="dtAdr">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_ADR" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_ADR" msprop:Generator_ColumnPropNameInRow="K_ADR" msprop:Generator_ColumnVarNameInTable="columnK_ADR" msprop:Generator_ColumnPropNameInTable="K_ADRColumn" type="xs:int" />
              <xs:element name="A_OBL" msprop:Generator_UserColumnName="A_OBL" msprop:Generator_ColumnPropNameInRow="A_OBL" msprop:Generator_ColumnVarNameInTable="columnA_OBL" msprop:Generator_ColumnPropNameInTable="A_OBLColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_GOROD" msprop:Generator_UserColumnName="A_GOROD" msprop:Generator_ColumnPropNameInRow="A_GOROD" msprop:Generator_ColumnVarNameInTable="columnA_GOROD" msprop:Generator_ColumnPropNameInTable="A_GORODColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_RN" msprop:Generator_UserColumnName="A_RN" msprop:Generator_ColumnPropNameInRow="A_RN" msprop:Generator_ColumnVarNameInTable="columnA_RN" msprop:Generator_ColumnPropNameInTable="A_RNColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_DOM" msprop:Generator_UserColumnName="A_DOM" msprop:Generator_ColumnPropNameInRow="A_DOM" msprop:Generator_ColumnVarNameInTable="columnA_DOM" msprop:Generator_ColumnPropNameInTable="A_DOMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="A_KORP" msprop:Generator_UserColumnName="A_KORP" msprop:Generator_ColumnPropNameInRow="A_KORP" msprop:Generator_ColumnVarNameInTable="columnA_KORP" msprop:Generator_ColumnPropNameInTable="A_KORPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="A_KV" msprop:Generator_UserColumnName="A_KV" msprop:Generator_ColumnPropNameInRow="A_KV" msprop:Generator_ColumnVarNameInTable="columnA_KV" msprop:Generator_ColumnPropNameInTable="A_KVColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RN_G" msprop:Generator_UserColumnName="K_RN_G" msprop:Generator_ColumnPropNameInRow="K_RN_G" msprop:Generator_ColumnVarNameInTable="columnK_RN_G" msprop:Generator_ColumnPropNameInTable="K_RN_GColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_UL" msprop:Generator_UserColumnName="K_UL" msprop:Generator_ColumnPropNameInRow="K_UL" msprop:Generator_ColumnVarNameInTable="columnK_UL" msprop:Generator_ColumnPropNameInTable="K_ULColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_TEL" msprop:Generator_UserColumnName="N_TEL" msprop:Generator_ColumnPropNameInRow="N_TEL" msprop:Generator_ColumnVarNameInTable="columnN_TEL" msprop:Generator_ColumnPropNameInTable="N_TELColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="F_TEL_RAB" msprop:Generator_UserColumnName="F_TEL_RAB" msprop:Generator_ColumnPropNameInRow="F_TEL_RAB" msprop:Generator_ColumnVarNameInTable="columnF_TEL_RAB" msprop:Generator_ColumnPropNameInTable="F_TEL_RABColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtSostavSemyi" msprop:Generator_UserTableName="dtSostavSemyi" msprop:Generator_RowDeletedName="dtSostavSemyiRowDeleted" msprop:Generator_RowChangedName="dtSostavSemyiRowChanged" msprop:Generator_RowClassName="dtSostavSemyiRow" msprop:Generator_RowChangingName="dtSostavSemyiRowChanging" msprop:Generator_RowEvArgName="dtSostavSemyiRowChangeEvent" msprop:Generator_RowEvHandlerName="dtSostavSemyiRowChangeEventHandler" msprop:Generator_TableClassName="dtSostavSemyiDataTable" msprop:Generator_TableVarName="tabledtSostavSemyi" msprop:Generator_RowDeletingName="dtSostavSemyiRowDeleting" msprop:Generator_TablePropName="dtSostavSemyi">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_SOSTAV_SEMYI" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_SOSTAV_SEMYI" msprop:Generator_ColumnPropNameInRow="K_SOSTAV_SEMYI" msprop:Generator_ColumnVarNameInTable="columnK_SOSTAV_SEMYI" msprop:Generator_ColumnPropNameInTable="K_SOSTAV_SEMYIColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_FA" msprop:Generator_UserColumnName="N_FA" msprop:Generator_ColumnPropNameInRow="N_FA" msprop:Generator_ColumnVarNameInTable="columnN_FA" msprop:Generator_ColumnPropNameInTable="N_FAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_IM" msprop:Generator_UserColumnName="N_IM" msprop:Generator_ColumnPropNameInRow="N_IM" msprop:Generator_ColumnVarNameInTable="columnN_IM" msprop:Generator_ColumnPropNameInTable="N_IMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="N_OT" msprop:Generator_UserColumnName="N_OT" msprop:Generator_ColumnPropNameInRow="N_OT" msprop:Generator_ColumnVarNameInTable="columnN_OT" msprop:Generator_ColumnPropNameInTable="N_OTColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GOD_R" msprop:Generator_UserColumnName="GOD_R" msprop:Generator_ColumnPropNameInRow="GOD_R" msprop:Generator_ColumnVarNameInTable="columnGOD_R" msprop:Generator_ColumnPropNameInTable="GOD_RColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_RODSTV_OTN" msprop:Generator_UserColumnName="K_RODSTV_OTN" msprop:Generator_ColumnPropNameInRow="K_RODSTV_OTN" msprop:Generator_ColumnVarNameInTable="columnK_RODSTV_OTN" msprop:Generator_ColumnPropNameInTable="K_RODSTV_OTNColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_PRIM" msprop:Generator_UserColumnName="N_PRIM" msprop:Generator_ColumnPropNameInRow="N_PRIM" msprop:Generator_ColumnVarNameInTable="columnN_PRIM" msprop:Generator_ColumnPropNameInTable="N_PRIMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="K_POL" msprop:Generator_UserColumnName="K_POL" msprop:Generator_ColumnPropNameInRow="K_POL" msprop:Generator_ColumnVarNameInTable="columnK_POL" msprop:Generator_ColumnPropNameInTable="K_POLColumn" type="xs:unsignedByte" default="2" minOccurs="0" />
              <xs:element name="C_LET" msprop:Generator_UserColumnName="C_LET" msprop:Generator_ColumnVarNameInTable="columnC_LET" msprop:Generator_ColumnPropNameInRow="C_LET" msprop:Generator_ColumnPropNameInTable="C_LETColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKpoPrich" msprop:Generator_UserTableName="dtKpoPrich" msprop:Generator_RowDeletedName="dtKpoPrichRowDeleted" msprop:Generator_RowChangedName="dtKpoPrichRowChanged" msprop:Generator_RowClassName="dtKpoPrichRow" msprop:Generator_RowChangingName="dtKpoPrichRowChanging" msprop:Generator_RowEvArgName="dtKpoPrichRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKpoPrichRowChangeEventHandler" msprop:Generator_TableClassName="dtKpoPrichDataTable" msprop:Generator_TableVarName="tabledtKpoPrich" msprop:Generator_RowDeletingName="dtKpoPrichRowDeleting" msprop:Generator_TablePropName="dtKpoPrich">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO_PRICH" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO_PRICH" msprop:Generator_ColumnPropNameInRow="K_KPO_PRICH" msprop:Generator_ColumnVarNameInTable="columnK_KPO_PRICH" msprop:Generator_ColumnPropNameInTable="K_KPO_PRICHColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_PRICH" msprop:Generator_UserColumnName="K_PRICH" msprop:Generator_ColumnPropNameInRow="K_PRICH" msprop:Generator_ColumnVarNameInTable="columnK_PRICH" msprop:Generator_ColumnPropNameInTable="K_PRICHColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKpoPom" msprop:Generator_UserTableName="dtKpoPom" msprop:Generator_RowDeletedName="dtKpoPomRowDeleted" msprop:Generator_RowChangedName="dtKpoPomRowChanged" msprop:Generator_RowClassName="dtKpoPomRow" msprop:Generator_RowChangingName="dtKpoPomRowChanging" msprop:Generator_RowEvArgName="dtKpoPomRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKpoPomRowChangeEventHandler" msprop:Generator_TableClassName="dtKpoPomDataTable" msprop:Generator_TableVarName="tabledtKpoPom" msprop:Generator_RowDeletingName="dtKpoPomRowDeleting" msprop:Generator_TablePropName="dtKpoPom">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO_POM" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO_POM" msprop:Generator_ColumnPropNameInRow="K_KPO_POM" msprop:Generator_ColumnVarNameInTable="columnK_KPO_POM" msprop:Generator_ColumnPropNameInTable="K_KPO_POMColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_POM" msprop:Generator_UserColumnName="K_POM" msprop:Generator_ColumnPropNameInRow="K_POM" msprop:Generator_ColumnVarNameInTable="columnK_POM" msprop:Generator_ColumnPropNameInTable="K_POMColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKpoHelpOrg" msprop:Generator_UserTableName="dtKpoHelpOrg" msprop:Generator_RowDeletedName="dtKpoHelpOrgRowDeleted" msprop:Generator_RowChangedName="dtKpoHelpOrgRowChanged" msprop:Generator_RowClassName="dtKpoHelpOrgRow" msprop:Generator_RowChangingName="dtKpoHelpOrgRowChanging" msprop:Generator_RowEvArgName="dtKpoHelpOrgRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKpoHelpOrgRowChangeEventHandler" msprop:Generator_TableClassName="dtKpoHelpOrgDataTable" msprop:Generator_TableVarName="tabledtKpoHelpOrg" msprop:Generator_RowDeletingName="dtKpoHelpOrgRowDeleting" msprop:Generator_TablePropName="dtKpoHelpOrg">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO_HELP_ORG" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO_HELP_ORG" msprop:Generator_ColumnPropNameInRow="K_KPO_HELP_ORG" msprop:Generator_ColumnVarNameInTable="columnK_KPO_HELP_ORG" msprop:Generator_ColumnPropNameInTable="K_KPO_HELP_ORGColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_HELP_ORG" msprop:Generator_UserColumnName="K_HELP_ORG" msprop:Generator_ColumnPropNameInRow="K_HELP_ORG" msprop:Generator_ColumnVarNameInTable="columnK_HELP_ORG" msprop:Generator_ColumnPropNameInTable="K_HELP_ORGColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtZhurnalObrasch" msprop:Generator_UserTableName="dtZhurnalObrasch" msprop:Generator_RowDeletedName="dtZhurnalObraschRowDeleted" msprop:Generator_RowChangedName="dtZhurnalObraschRowChanged" msprop:Generator_RowClassName="dtZhurnalObraschRow" msprop:Generator_RowChangingName="dtZhurnalObraschRowChanging" msprop:Generator_RowEvArgName="dtZhurnalObraschRowChangeEvent" msprop:Generator_RowEvHandlerName="dtZhurnalObraschRowChangeEventHandler" msprop:Generator_TableClassName="dtZhurnalObraschDataTable" msprop:Generator_TableVarName="tabledtZhurnalObrasch" msprop:Generator_RowDeletingName="dtZhurnalObraschRowDeleting" msprop:Generator_TablePropName="dtZhurnalObrasch">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="C_NPP" msdata:ReadOnly="true" msprop:Generator_UserColumnName="C_NPP" msprop:Generator_ColumnPropNameInRow="C_NPP" msprop:Generator_ColumnVarNameInTable="columnC_NPP" msprop:Generator_ColumnPropNameInTable="C_NPPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="D_OBRASCH" msdata:ReadOnly="true" msprop:Generator_UserColumnName="D_OBRASCH" msprop:Generator_ColumnPropNameInRow="D_OBRASCH" msprop:Generator_ColumnVarNameInTable="columnD_OBRASCH" msprop:Generator_ColumnPropNameInTable="D_OBRASCHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="F_PROVEDENA" msdata:ReadOnly="true" msprop:Generator_UserColumnName="F_PROVEDENA" msprop:Generator_ColumnPropNameInRow="F_PROVEDENA" msprop:Generator_ColumnVarNameInTable="columnF_PROVEDENA" msprop:Generator_ColumnPropNameInTable="F_PROVEDENAColumn" type="xs:boolean" />
              <xs:element name="K_KPO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="N_FIO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="N_FIO" msprop:Generator_ColumnPropNameInRow="N_FIO" msprop:Generator_ColumnVarNameInTable="columnN_FIO" msprop:Generator_ColumnPropNameInTable="N_FIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="152" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtKpoProb" msprop:Generator_UserTableName="dtKpoProb" msprop:Generator_RowDeletedName="dtKpoProbRowDeleted" msprop:Generator_RowChangedName="dtKpoProbRowChanged" msprop:Generator_RowClassName="dtKpoProbRow" msprop:Generator_RowChangingName="dtKpoProbRowChanging" msprop:Generator_RowEvArgName="dtKpoProbRowChangeEvent" msprop:Generator_RowEvHandlerName="dtKpoProbRowChangeEventHandler" msprop:Generator_TableClassName="dtKpoProbDataTable" msprop:Generator_TableVarName="tabledtKpoProb" msprop:Generator_RowDeletingName="dtKpoProbRowDeleting" msprop:Generator_TablePropName="dtKpoProb">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_KPO_PROB" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_KPO_PROB" msprop:Generator_ColumnPropNameInRow="K_KPO_PROB" msprop:Generator_ColumnVarNameInTable="columnK_KPO_PROB" msprop:Generator_ColumnPropNameInTable="K_KPO_PROBColumn" type="xs:int" />
              <xs:element name="K_KPO" msprop:Generator_UserColumnName="K_KPO" msprop:Generator_ColumnPropNameInRow="K_KPO" msprop:Generator_ColumnVarNameInTable="columnK_KPO" msprop:Generator_ColumnPropNameInTable="K_KPOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_PROB" msprop:Generator_UserColumnName="K_PROB" msprop:Generator_ColumnPropNameInRow="K_PROB" msprop:Generator_ColumnVarNameInTable="columnK_PROB" msprop:Generator_ColumnPropNameInTable="K_PROBColumn" type="xs:int" minOccurs="0" />
              <xs:element name="K_PROB_TIP" msprop:Generator_UserColumnName="K_PROB_TIP" msprop:Generator_ColumnPropNameInRow="K_PROB_TIP" msprop:Generator_ColumnVarNameInTable="columnK_PROB_TIP" msprop:Generator_ColumnPropNameInTable="K_PROB_TIPColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtUKS" msprop:Generator_UserTableName="dtUKS" msprop:Generator_RowDeletedName="dtUKSRowDeleted" msprop:Generator_RowChangedName="dtUKSRowChanged" msprop:Generator_RowClassName="dtUKSRow" msprop:Generator_RowChangingName="dtUKSRowChanging" msprop:Generator_RowEvArgName="dtUKSRowChangeEvent" msprop:Generator_RowEvHandlerName="dtUKSRowChangeEventHandler" msprop:Generator_TableClassName="dtUKSDataTable" msprop:Generator_TableVarName="tabledtUKS" msprop:Generator_RowDeletingName="dtUKSRowDeleting" msprop:Generator_TablePropName="dtUKS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="K_UKS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="K_UKS" msprop:Generator_ColumnPropNameInRow="K_UKS" msprop:Generator_ColumnVarNameInTable="columnK_UKS" msprop:Generator_ColumnPropNameInTable="K_UKSColumn" type="xs:int" />
              <xs:element name="NPP_UKS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="NPP_UKS" msprop:Generator_ColumnPropNameInRow="NPP_UKS" msprop:Generator_ColumnVarNameInTable="columnNPP_UKS" msprop:Generator_ColumnPropNameInTable="NPP_UKSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="27" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKPO" />
      <xs:field xpath="mstns:K_KPO" />
    </xs:unique>
    <xs:unique name="dtAdr_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtAdr" />
      <xs:field xpath="mstns:K_ADR" />
    </xs:unique>
    <xs:unique name="dtSostavSemyi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtSostavSemyi" />
      <xs:field xpath="mstns:K_SOSTAV_SEMYI" />
    </xs:unique>
    <xs:unique name="dtKpoPrich_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKpoPrich" />
      <xs:field xpath="mstns:K_KPO_PRICH" />
    </xs:unique>
    <xs:unique name="dtKpoPom_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKpoPom" />
      <xs:field xpath="mstns:K_KPO_POM" />
    </xs:unique>
    <xs:unique name="dtKpoHelpOrg_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKpoHelpOrg" />
      <xs:field xpath="mstns:K_KPO_HELP_ORG" />
    </xs:unique>
    <xs:unique name="dtKpoProb_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtKpoProb" />
      <xs:field xpath="mstns:K_KPO_PROB" />
    </xs:unique>
    <xs:unique name="dtUKS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtUKS" />
      <xs:field xpath="mstns:K_UKS" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="dtKPO_dtAdr" msdata:parent="dtKPO" msdata:child="dtAdr" msdata:parentkey="K_ADR" msdata:childkey="K_ADR" msprop:Generator_UserRelationName="dtKPO_dtAdr" msprop:Generator_RelationVarName="relationdtKPO_dtAdr" msprop:Generator_UserChildTable="dtAdr" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtAdrRows" />
      <msdata:Relationship name="dtKPO_dtSostavSemyi" msdata:parent="dtKPO" msdata:child="dtSostavSemyi" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_dtSostavSemyi" msprop:Generator_RelationVarName="relationdtKPO_dtSostavSemyi" msprop:Generator_UserChildTable="dtSostavSemyi" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtSostavSemyiRows" />
      <msdata:Relationship name="dtKPO_sv_kpo_prich" msdata:parent="dtKPO" msdata:child="dtKpoPrich" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_sv_kpo_prich" msprop:Generator_RelationVarName="relationdtKPO_sv_kpo_prich" msprop:Generator_UserChildTable="dtKpoPrich" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtKpoPrichRows" />
      <msdata:Relationship name="dtKPO_dtSvKpoHelpOrg" msdata:parent="dtKPO" msdata:child="dtKpoHelpOrg" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_dtSvKpoHelpOrg" msprop:Generator_RelationVarName="relationdtKPO_dtSvKpoHelpOrg" msprop:Generator_UserChildTable="dtKpoHelpOrg" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtKpoHelpOrgRows" />
      <msdata:Relationship name="dtKPO_dtZhurnalObrasch" msdata:parent="dtKPO" msdata:child="dtZhurnalObrasch" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_dtZhurnalObrasch" msprop:Generator_RelationVarName="relationdtKPO_dtZhurnalObrasch" msprop:Generator_UserChildTable="dtZhurnalObrasch" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtZhurnalObraschRows" />
      <msdata:Relationship name="dtKPO_b_uks" msdata:parent="dtKPO" msdata:child="dtUKS" msdata:parentkey="K_UKS" msdata:childkey="K_UKS" msprop:Generator_UserRelationName="dtKPO_b_uks" msprop:Generator_RelationVarName="relationdtKPO_b_uks" msprop:Generator_UserChildTable="dtUKS" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtUKSRows" />
      <msdata:Relationship name="dtKPO_dtSvKpoProb" msdata:parent="dtKPO" msdata:child="dtKpoProb" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_dtSvKpoProb" msprop:Generator_RelationVarName="relationdtKPO_dtSvKpoProb" msprop:Generator_UserChildTable="dtKpoProb" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtKpoProbRows" />
      <msdata:Relationship name="dtKPO_sv_kpo_pom" msdata:parent="dtKPO" msdata:child="dtKpoPom" msdata:parentkey="K_KPO" msdata:childkey="K_KPO" msprop:Generator_UserRelationName="dtKPO_sv_kpo_pom" msprop:Generator_RelationVarName="relationdtKPO_sv_kpo_pom" msprop:Generator_UserChildTable="dtKpoPom" msprop:Generator_UserParentTable="dtKPO" msprop:Generator_ParentPropName="dtKPORow" msprop:Generator_ChildPropName="GetdtKpoPomRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>